package com.pd.backend.dao.provider;

import com.pd.backend.vo.req.PdOrderGetPageReqVo;
import org.apache.ibatis.jdbc.SQL;

/**
 * @ClassName PdOrderDaoProvider
 * @Description TODO
 * @date 2023/3/1 1:52
 * @Version 1.0
 */
public class PdOrderDaoProvider {
    public String selectOrderOne(PdOrderGetPageReqVo pdOrderGetPageReqVo){
        SQL sql = new SQL();
        SQL sql1 = new SQL();
        sql1.SELECT("ORDER_ID").FROM("pd_transport_order").WHERE("ID="+pdOrderGetPageReqVo.getId());
        sql.SELECT("*").FROM("pd_order").WHERE("id="+"("+sql1+")");

        return sql.toString();
    }
}
